Overview
Brought to you by YData
Dataset statistics
| Number of variables | 32 |
|---|---|
| Number of observations | 9758 |
| Missing cells | 49932 |
| Missing cells (%) | 16.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 6.5 MiB |
| Average record size in memory | 703.3 B |
Variable types
| DateTime | 1 |
|---|---|
| Categorical | 5 |
| Numeric | 21 |
| Text | 4 |
| Unsupported | 1 |
CANCELLED has constant value "0.0" | Constant |
AIRLINE is highly overall correlated with AIRLINE_CODE and 2 other fields | High correlation |
AIRLINE_CODE is highly overall correlated with AIRLINE and 2 other fields | High correlation |
AIRLINE_DOT is highly overall correlated with AIRLINE and 2 other fields | High correlation |
AIR_TIME is highly overall correlated with CRS_ELAPSED_TIME and 3 other fields | High correlation |
ARR_DELAY is highly overall correlated with DEP_DELAY and 1 other fields | High correlation |
ARR_TIME is highly overall correlated with CRS_ARR_TIME and 4 other fields | High correlation |
CRS_ARR_TIME is highly overall correlated with ARR_TIME and 4 other fields | High correlation |
CRS_DEP_TIME is highly overall correlated with ARR_TIME and 4 other fields | High correlation |
CRS_ELAPSED_TIME is highly overall correlated with AIR_TIME and 2 other fields | High correlation |
DELAY_DUE_CARRIER is highly overall correlated with DIVERTED | High correlation |
DELAY_DUE_LATE_AIRCRAFT is highly overall correlated with DIVERTED | High correlation |
DELAY_DUE_NAS is highly overall correlated with DIVERTED | High correlation |
DELAY_DUE_SECURITY is highly overall correlated with DIVERTED | High correlation |
DELAY_DUE_WEATHER is highly overall correlated with DIVERTED | High correlation |
DEP_DELAY is highly overall correlated with ARR_DELAY | High correlation |
DEP_TIME is highly overall correlated with ARR_TIME and 4 other fields | High correlation |
DISTANCE is highly overall correlated with AIR_TIME and 2 other fields | High correlation |
DIVERTED is highly overall correlated with AIR_TIME and 7 other fields | High correlation |
DOT_CODE is highly overall correlated with AIRLINE and 2 other fields | High correlation |
ELAPSED_TIME is highly overall correlated with AIR_TIME and 3 other fields | High correlation |
WHEELS_OFF is highly overall correlated with ARR_TIME and 4 other fields | High correlation |
WHEELS_ON is highly overall correlated with ARR_TIME and 4 other fields | High correlation |
DIVERTED is highly imbalanced (98.0%) | Imbalance |
CANCELLATION_CODE has 9758 (100.0%) missing values | Missing |
DELAY_DUE_CARRIER has 8021 (82.2%) missing values | Missing |
DELAY_DUE_WEATHER has 8021 (82.2%) missing values | Missing |
DELAY_DUE_NAS has 8021 (82.2%) missing values | Missing |
DELAY_DUE_SECURITY has 8021 (82.2%) missing values | Missing |
DELAY_DUE_LATE_AIRCRAFT has 8021 (82.2%) missing values | Missing |
CANCELLATION_CODE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
DEP_DELAY has 463 (4.7%) zeros | Zeros |
ARR_DELAY has 173 (1.8%) zeros | Zeros |
DELAY_DUE_CARRIER has 762 (7.8%) zeros | Zeros |
DELAY_DUE_WEATHER has 1640 (16.8%) zeros | Zeros |
DELAY_DUE_NAS has 894 (9.2%) zeros | Zeros |
DELAY_DUE_SECURITY has 1724 (17.7%) zeros | Zeros |
DELAY_DUE_LATE_AIRCRAFT has 840 (8.6%) zeros | Zeros |
Reproduction
| Analysis started | 2025-07-17 04:02:30.395033 |
|---|---|
| Analysis finished | 2025-07-17 04:02:51.968823 |
| Duration | 21.57 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
FL_DATE
Date
| Distinct | 1683 |
|---|---|
| Distinct (%) | 17.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 152.5 KiB |
| Minimum | 2019-01-01 00:00:00 |
|---|---|
| Maximum | 2023-08-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
AIRLINE
Categorical
High correlation
| Distinct | 18 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 729.8 KiB |
| Southwest Airlines Co. | |
|---|---|
| Delta Air Lines Inc. | |
| American Airlines Inc. | |
| SkyWest Airlines Inc. | |
| United Air Lines Inc. | |
| Other values (13) |
Length
| Max length | 34 |
|---|---|
| Median length | 22 |
| Mean length | 19.581882 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SkyWest Airlines Inc. |
|---|---|
| 2nd row | Republic Airline |
| 3rd row | SkyWest Airlines Inc. |
| 4th row | United Air Lines Inc. |
| 5th row | United Air Lines Inc. |
Common Values
| Value | Count | Frequency (%) |
| Southwest Airlines Co. | 1901 | |
| Delta Air Lines Inc. | 1346 | |
| American Airlines Inc. | 1207 | |
| SkyWest Airlines Inc. | 1101 | |
| United Air Lines Inc. | 826 | |
| Republic Airline | 462 | 4.7% |
| Envoy Air | 400 | 4.1% |
| JetBlue Airways | 360 | 3.7% |
| PSA Airlines Inc. | 353 | 3.6% |
| Endeavor Air Inc. | 353 | 3.6% |
| Other values (8) | 1449 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| inc | 6047 | |
| airlines | 5473 | |
| air | 3463 | |
| lines | 2467 | |
| southwest | 1901 | 6.3% |
| co | 1901 | 6.3% |
| delta | 1346 | 4.5% |
| american | 1207 | 4.0% |
| skywest | 1101 | 3.7% |
| united | 826 | 2.7% |
| Other values (18) | 4349 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 21928 | |
| 20323 | 10.6% | |
| n | 17813 | 9.3% |
| e | 17030 | 8.9% |
| r | 12190 | 6.4% |
| s | 11928 | 6.2% |
| A | 11814 | 6.2% |
| l | 8775 | 4.6% |
| t | 8186 | 4.3% |
| . | 7948 | 4.2% |
| Other values (33) | 53145 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 191080 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 21928 | |
| 20323 | 10.6% | |
| n | 17813 | 9.3% |
| e | 17030 | 8.9% |
| r | 12190 | 6.4% |
| s | 11928 | 6.2% |
| A | 11814 | 6.2% |
| l | 8775 | 4.6% |
| t | 8186 | 4.3% |
| . | 7948 | 4.2% |
| Other values (33) | 53145 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 191080 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 21928 | |
| 20323 | 10.6% | |
| n | 17813 | 9.3% |
| e | 17030 | 8.9% |
| r | 12190 | 6.4% |
| s | 11928 | 6.2% |
| A | 11814 | 6.2% |
| l | 8775 | 4.6% |
| t | 8186 | 4.3% |
| . | 7948 | 4.2% |
| Other values (33) | 53145 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 191080 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 21928 | |
| 20323 | 10.6% | |
| n | 17813 | 9.3% |
| e | 17030 | 8.9% |
| r | 12190 | 6.4% |
| s | 11928 | 6.2% |
| A | 11814 | 6.2% |
| l | 8775 | 4.6% |
| t | 8186 | 4.3% |
| . | 7948 | 4.2% |
| Other values (33) | 53145 |
AIRLINE_DOT
Categorical
High correlation
| Distinct | 18 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 767.9 KiB |
| Southwest Airlines Co.: WN | |
|---|---|
| Delta Air Lines Inc.: DL | |
| American Airlines Inc.: AA | |
| SkyWest Airlines Inc.: OO | |
| United Air Lines Inc.: UA | |
| Other values (13) |
Length
| Max length | 38 |
|---|---|
| Median length | 26 |
| Mean length | 23.581882 |
| Min length | 13 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SkyWest Airlines Inc.: OO |
|---|---|
| 2nd row | Republic Airline: YX |
| 3rd row | SkyWest Airlines Inc.: OO |
| 4th row | United Air Lines Inc.: UA |
| 5th row | United Air Lines Inc.: UA |
Common Values
| Value | Count | Frequency (%) |
| Southwest Airlines Co.: WN | 1901 | |
| Delta Air Lines Inc.: DL | 1346 | |
| American Airlines Inc.: AA | 1207 | |
| SkyWest Airlines Inc.: OO | 1101 | |
| United Air Lines Inc.: UA | 826 | |
| Republic Airline: YX | 462 | 4.7% |
| Envoy Air: MQ | 400 | 4.1% |
| JetBlue Airways: B6 | 360 | 3.7% |
| PSA Airlines Inc.: OH | 353 | 3.6% |
| Endeavor Air Inc.: 9E | 353 | 3.6% |
| Other values (8) | 1449 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| inc | 6047 | |
| airlines | 5473 | |
| air | 3463 | 8.7% |
| lines | 2467 | 6.2% |
| southwest | 1901 | 4.8% |
| co | 1901 | 4.8% |
| wn | 1901 | 4.8% |
| delta | 1346 | 3.4% |
| dl | 1346 | 3.4% |
| american | 1207 | 3.0% |
| Other values (36) | 12787 |
Most occurring characters
| Value | Count | Frequency (%) |
| 30081 | 13.1% | |
| i | 21928 | 9.5% |
| n | 17813 | 7.7% |
| e | 17030 | 7.4% |
| A | 15479 | 6.7% |
| r | 12190 | 5.3% |
| s | 11928 | 5.2% |
| : | 9758 | 4.2% |
| l | 8775 | 3.8% |
| t | 8186 | 3.6% |
| Other values (45) | 76944 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 230112 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 30081 | 13.1% | |
| i | 21928 | 9.5% |
| n | 17813 | 7.7% |
| e | 17030 | 7.4% |
| A | 15479 | 6.7% |
| r | 12190 | 5.3% |
| s | 11928 | 5.2% |
| : | 9758 | 4.2% |
| l | 8775 | 3.8% |
| t | 8186 | 3.6% |
| Other values (45) | 76944 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 230112 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 30081 | 13.1% | |
| i | 21928 | 9.5% |
| n | 17813 | 7.7% |
| e | 17030 | 7.4% |
| A | 15479 | 6.7% |
| r | 12190 | 5.3% |
| s | 11928 | 5.2% |
| : | 9758 | 4.2% |
| l | 8775 | 3.8% |
| t | 8186 | 3.6% |
| Other values (45) | 76944 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 230112 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 30081 | 13.1% | |
| i | 21928 | 9.5% |
| n | 17813 | 7.7% |
| e | 17030 | 7.4% |
| A | 15479 | 6.7% |
| r | 12190 | 5.3% |
| s | 11928 | 5.2% |
| : | 9758 | 4.2% |
| l | 8775 | 3.8% |
| t | 8186 | 3.6% |
| Other values (45) | 76944 |
AIRLINE_CODE
Categorical
High correlation
| Distinct | 18 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 562.2 KiB |
| WN | |
|---|---|
| DL | |
| AA | |
| OO | |
| UA | |
| Other values (13) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | OO |
|---|---|
| 2nd row | YX |
| 3rd row | OO |
| 4th row | UA |
| 5th row | UA |
Common Values
| Value | Count | Frequency (%) |
| WN | 1901 | |
| DL | 1346 | |
| AA | 1207 | |
| OO | 1101 | |
| UA | 826 | |
| YX | 462 | 4.7% |
| MQ | 400 | 4.1% |
| B6 | 360 | 3.7% |
| OH | 353 | 3.6% |
| 9E | 353 | 3.6% |
| Other values (8) | 1449 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| wn | 1901 | |
| dl | 1346 | |
| aa | 1207 | |
| oo | 1101 | |
| ua | 826 | |
| yx | 462 | 4.7% |
| mq | 400 | 4.1% |
| b6 | 360 | 3.7% |
| oh | 353 | 3.6% |
| 9e | 353 | 3.6% |
| Other values (8) | 1449 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 3665 | |
| O | 2555 | |
| N | 2196 | |
| W | 1901 | |
| L | 1346 | 6.9% |
| D | 1346 | 6.9% |
| U | 826 | 4.2% |
| Y | 668 | 3.4% |
| 9 | 583 | 3.0% |
| X | 529 | 2.7% |
| Other values (12) | 3901 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 19516 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 3665 | |
| O | 2555 | |
| N | 2196 | |
| W | 1901 | |
| L | 1346 | 6.9% |
| D | 1346 | 6.9% |
| U | 826 | 4.2% |
| Y | 668 | 3.4% |
| 9 | 583 | 3.0% |
| X | 529 | 2.7% |
| Other values (12) | 3901 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 19516 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 3665 | |
| O | 2555 | |
| N | 2196 | |
| W | 1901 | |
| L | 1346 | 6.9% |
| D | 1346 | 6.9% |
| U | 826 | 4.2% |
| Y | 668 | 3.4% |
| 9 | 583 | 3.0% |
| X | 529 | 2.7% |
| Other values (12) | 3901 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 19516 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 3665 | |
| O | 2555 | |
| N | 2196 | |
| W | 1901 | |
| L | 1346 | 6.9% |
| D | 1346 | 6.9% |
| U | 826 | 4.2% |
| Y | 668 | 3.4% |
| 9 | 583 | 3.0% |
| X | 529 | 2.7% |
| Other values (12) | 3901 |
DOT_CODE
Real number (ℝ)
High correlation
| Distinct | 18 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19972.877 |
| Minimum | 19393 |
|---|---|
| Maximum | 20452 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 19393 |
|---|---|
| 5-th percentile | 19393 |
| Q1 | 19790 |
| median | 19930 |
| Q3 | 20368 |
| 95-th percentile | 20436 |
| Maximum | 20452 |
| Range | 1059 |
| Interquartile range (IQR) | 578 |
Descriptive statistics
| Standard deviation | 377.95251 |
|---|---|
| Coefficient of variation (CV) | 0.018923288 |
| Kurtosis | -1.3183646 |
| Mean | 19972.877 |
| Median Absolute Deviation (MAD) | 374 |
| Skewness | -0.21494203 |
| Sum | 1.9489533 × 108 |
| Variance | 142848.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=18)
| Value | Count | Frequency (%) |
| 19393 | 1901 | |
| 19790 | 1346 | |
| 19805 | 1207 | |
| 20304 | 1101 | |
| 19977 | 826 | |
| 20452 | 462 | 4.7% |
| 20398 | 400 | 4.1% |
| 20409 | 360 | 3.7% |
| 20397 | 353 | 3.6% |
| 20363 | 353 | 3.6% |
| Other values (8) | 1449 |
| Value | Count | Frequency (%) |
| 19393 | 1901 | |
| 19687 | 67 | 0.7% |
| 19690 | 105 | 1.1% |
| 19790 | 1346 | |
| 19805 | 1207 | |
| 19930 | 320 | 3.3% |
| 19977 | 826 | |
| 20304 | 1101 | |
| 20363 | 353 | 3.6% |
| 20366 | 50 | 0.5% |
| Value | Count | Frequency (%) |
| 20452 | 462 | |
| 20436 | 230 | |
| 20416 | 295 | |
| 20409 | 360 | |
| 20398 | 400 | |
| 20397 | 353 | |
| 20378 | 206 | |
| 20368 | 176 | 1.8% |
| 20366 | 50 | 0.5% |
| 20363 | 353 |
FL_NUMBER
Real number (ℝ)
| Distinct | 4620 |
|---|---|
| Distinct (%) | 47.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2505.3074 |
| Minimum | 1 |
|---|---|
| Maximum | 7431 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 271 |
| Q1 | 1037.25 |
| median | 2144.5 |
| Q3 | 3782.75 |
| 95-th percentile | 5635.15 |
| Maximum | 7431 |
| Range | 7430 |
| Interquartile range (IQR) | 2745.5 |
Descriptive statistics
| Standard deviation | 1740.4628 |
|---|---|
| Coefficient of variation (CV) | 0.69471028 |
| Kurtosis | -0.88868511 |
| Mean | 2505.3074 |
| Median Absolute Deviation (MAD) | 1340.5 |
| Skewness | 0.50876545 |
| Sum | 24446790 |
| Variance | 3029210.9 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 546 | 11 | 0.1% |
| 922 | 8 | 0.1% |
| 375 | 8 | 0.1% |
| 62 | 8 | 0.1% |
| 1517 | 8 | 0.1% |
| 573 | 8 | 0.1% |
| 2255 | 8 | 0.1% |
| 1701 | 7 | 0.1% |
| 5102 | 7 | 0.1% |
| 529 | 7 | 0.1% |
| Other values (4610) | 9678 |
| Value | Count | Frequency (%) |
| 1 | 3 | |
| 2 | 3 | |
| 3 | 3 | |
| 4 | 6 | |
| 5 | 3 | |
| 6 | 2 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 3 | |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 7431 | 1 | |
| 7395 | 1 | |
| 7393 | 1 | |
| 7389 | 1 | |
| 7387 | 1 | |
| 7385 | 1 | |
| 7381 | 1 | |
| 7378 | 1 | |
| 6960 | 1 | |
| 6957 | 1 |
ORIGIN
Text
| Distinct | 317 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.8 KiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 68 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | SAN |
|---|---|
| 2nd row | CMH |
| 3rd row | CVG |
| 4th row | DEN |
| 5th row | IAH |
| Value | Count | Frequency (%) |
| atl | 532 | 5.5% |
| ord | 410 | 4.2% |
| dfw | 394 | 4.0% |
| den | 363 | 3.7% |
| clt | 334 | 3.4% |
| lax | 268 | 2.7% |
| phx | 266 | 2.7% |
| las | 215 | 2.2% |
| sea | 210 | 2.2% |
| sfo | 206 | 2.1% |
| Other values (307) | 6560 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 3237 | 11.1% |
| L | 2740 | 9.4% |
| S | 2452 | 8.4% |
| D | 2275 | 7.8% |
| T | 1689 | 5.8% |
| C | 1497 | 5.1% |
| O | 1495 | 5.1% |
| M | 1269 | 4.3% |
| F | 1197 | 4.1% |
| P | 1187 | 4.1% |
| Other values (16) | 10236 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 29274 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 3237 | 11.1% |
| L | 2740 | 9.4% |
| S | 2452 | 8.4% |
| D | 2275 | 7.8% |
| T | 1689 | 5.8% |
| C | 1497 | 5.1% |
| O | 1495 | 5.1% |
| M | 1269 | 4.3% |
| F | 1197 | 4.1% |
| P | 1187 | 4.1% |
| Other values (16) | 10236 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 29274 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 3237 | 11.1% |
| L | 2740 | 9.4% |
| S | 2452 | 8.4% |
| D | 2275 | 7.8% |
| T | 1689 | 5.8% |
| C | 1497 | 5.1% |
| O | 1495 | 5.1% |
| M | 1269 | 4.3% |
| F | 1197 | 4.1% |
| P | 1187 | 4.1% |
| Other values (16) | 10236 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 29274 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 3237 | 11.1% |
| L | 2740 | 9.4% |
| S | 2452 | 8.4% |
| D | 2275 | 7.8% |
| T | 1689 | 5.8% |
| C | 1497 | 5.1% |
| O | 1495 | 5.1% |
| M | 1269 | 4.3% |
| F | 1197 | 4.1% |
| P | 1187 | 4.1% |
| Other values (16) | 10236 |
ORIGIN_CITY
Text
| Distinct | 312 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 668.0 KiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.094384 |
| Min length | 8 |
Unique
| Unique | 69 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | San Diego, CA |
|---|---|
| 2nd row | Columbus, OH |
| 3rd row | Cincinnati, OH |
| 4th row | Denver, CO |
| 5th row | Houston, TX |
| Value | Count | Frequency (%) |
| tx | 1045 | 4.6% |
| ca | 1041 | 4.6% |
| fl | 832 | 3.7% |
| ga | 565 | 2.5% |
| il | 553 | 2.4% |
| atlanta | 532 | 2.3% |
| chicago | 528 | 2.3% |
| san | 517 | 2.3% |
| ny | 475 | 2.1% |
| nc | 468 | 2.1% |
| Other values (385) | 16099 |
Most occurring characters
| Value | Count | Frequency (%) |
| 12897 | 10.1% | |
| a | 9768 | 7.6% |
| , | 9758 | 7.6% |
| o | 7153 | 5.6% |
| e | 6663 | 5.2% |
| n | 6340 | 5.0% |
| t | 6256 | 4.9% |
| l | 5725 | 4.5% |
| i | 5008 | 3.9% |
| r | 4549 | 3.6% |
| Other values (47) | 53658 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 127775 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 12897 | 10.1% | |
| a | 9768 | 7.6% |
| , | 9758 | 7.6% |
| o | 7153 | 5.6% |
| e | 6663 | 5.2% |
| n | 6340 | 5.0% |
| t | 6256 | 4.9% |
| l | 5725 | 4.5% |
| i | 5008 | 3.9% |
| r | 4549 | 3.6% |
| Other values (47) | 53658 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 127775 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 12897 | 10.1% | |
| a | 9768 | 7.6% |
| , | 9758 | 7.6% |
| o | 7153 | 5.6% |
| e | 6663 | 5.2% |
| n | 6340 | 5.0% |
| t | 6256 | 4.9% |
| l | 5725 | 4.5% |
| i | 5008 | 3.9% |
| r | 4549 | 3.6% |
| Other values (47) | 53658 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 127775 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 12897 | 10.1% | |
| a | 9768 | 7.6% |
| , | 9758 | 7.6% |
| o | 7153 | 5.6% |
| e | 6663 | 5.2% |
| n | 6340 | 5.0% |
| t | 6256 | 4.9% |
| l | 5725 | 4.5% |
| i | 5008 | 3.9% |
| r | 4549 | 3.6% |
| Other values (47) | 53658 |
DEST
Text
| Distinct | 307 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.8 KiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 55 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | SFO |
|---|---|
| 2nd row | ORD |
| 3rd row | ORD |
| 4th row | MCI |
| 5th row | SFO |
| Value | Count | Frequency (%) |
| atl | 527 | 5.4% |
| den | 410 | 4.2% |
| dfw | 400 | 4.1% |
| ord | 364 | 3.7% |
| lax | 291 | 3.0% |
| clt | 288 | 3.0% |
| phx | 257 | 2.6% |
| dtw | 240 | 2.5% |
| las | 234 | 2.4% |
| sea | 232 | 2.4% |
| Other values (297) | 6515 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 3296 | 11.3% |
| L | 2757 | 9.4% |
| S | 2395 | 8.2% |
| D | 2294 | 7.8% |
| T | 1685 | 5.8% |
| C | 1462 | 5.0% |
| O | 1442 | 4.9% |
| M | 1273 | 4.3% |
| F | 1191 | 4.1% |
| P | 1174 | 4.0% |
| Other values (16) | 10305 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 29274 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 3296 | 11.3% |
| L | 2757 | 9.4% |
| S | 2395 | 8.2% |
| D | 2294 | 7.8% |
| T | 1685 | 5.8% |
| C | 1462 | 5.0% |
| O | 1442 | 4.9% |
| M | 1273 | 4.3% |
| F | 1191 | 4.1% |
| P | 1174 | 4.0% |
| Other values (16) | 10305 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 29274 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 3296 | 11.3% |
| L | 2757 | 9.4% |
| S | 2395 | 8.2% |
| D | 2294 | 7.8% |
| T | 1685 | 5.8% |
| C | 1462 | 5.0% |
| O | 1442 | 4.9% |
| M | 1273 | 4.3% |
| F | 1191 | 4.1% |
| P | 1174 | 4.0% |
| Other values (16) | 10305 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 29274 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 3296 | 11.3% |
| L | 2757 | 9.4% |
| S | 2395 | 8.2% |
| D | 2294 | 7.8% |
| T | 1685 | 5.8% |
| C | 1462 | 5.0% |
| O | 1442 | 4.9% |
| M | 1273 | 4.3% |
| F | 1191 | 4.1% |
| P | 1174 | 4.0% |
| Other values (16) | 10305 |
DEST_CITY
Text
| Distinct | 302 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 667.9 KiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.088543 |
| Min length | 8 |
Unique
| Unique | 55 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | San Francisco, CA |
|---|---|
| 2nd row | Chicago, IL |
| 3rd row | Chicago, IL |
| 4th row | Kansas City, MO |
| 5th row | San Francisco, CA |
| Value | Count | Frequency (%) |
| ca | 1059 | 4.7% |
| tx | 1014 | 4.5% |
| fl | 869 | 3.8% |
| ga | 562 | 2.5% |
| atlanta | 527 | 2.3% |
| il | 496 | 2.2% |
| ny | 484 | 2.1% |
| chicago | 470 | 2.1% |
| san | 456 | 2.0% |
| co | 448 | 2.0% |
| Other values (381) | 16284 |
Most occurring characters
| Value | Count | Frequency (%) |
| 12911 | 10.1% | |
| a | 9767 | 7.6% |
| , | 9758 | 7.6% |
| o | 7049 | 5.5% |
| e | 6796 | 5.3% |
| t | 6385 | 5.0% |
| n | 6242 | 4.9% |
| l | 5734 | 4.5% |
| i | 4866 | 3.8% |
| r | 4704 | 3.7% |
| Other values (48) | 53506 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 127718 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 12911 | 10.1% | |
| a | 9767 | 7.6% |
| , | 9758 | 7.6% |
| o | 7049 | 5.5% |
| e | 6796 | 5.3% |
| t | 6385 | 5.0% |
| n | 6242 | 4.9% |
| l | 5734 | 4.5% |
| i | 4866 | 3.8% |
| r | 4704 | 3.7% |
| Other values (48) | 53506 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 127718 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 12911 | 10.1% | |
| a | 9767 | 7.6% |
| , | 9758 | 7.6% |
| o | 7049 | 5.5% |
| e | 6796 | 5.3% |
| t | 6385 | 5.0% |
| n | 6242 | 4.9% |
| l | 5734 | 4.5% |
| i | 4866 | 3.8% |
| r | 4704 | 3.7% |
| Other values (48) | 53506 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 127718 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 12911 | 10.1% | |
| a | 9767 | 7.6% |
| , | 9758 | 7.6% |
| o | 7049 | 5.5% |
| e | 6796 | 5.3% |
| t | 6385 | 5.0% |
| n | 6242 | 4.9% |
| l | 5734 | 4.5% |
| i | 4866 | 3.8% |
| r | 4704 | 3.7% |
| Other values (48) | 53506 |
CRS_DEP_TIME
Real number (ℝ)
High correlation
| Distinct | 1058 |
|---|---|
| Distinct (%) | 10.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1336.3331 |
| Minimum | 9 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 605 |
| Q1 | 925 |
| median | 1325 |
| Q3 | 1735 |
| 95-th percentile | 2116.15 |
| Maximum | 2359 |
| Range | 2350 |
| Interquartile range (IQR) | 810 |
Descriptive statistics
| Standard deviation | 485.12895 |
|---|---|
| Coefficient of variation (CV) | 0.36302997 |
| Kurtosis | -1.0269398 |
| Mean | 1336.3331 |
| Median Absolute Deviation (MAD) | 405 |
| Skewness | 0.061249549 |
| Sum | 13039938 |
| Variance | 235350.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 600 | 206 | 2.1% |
| 700 | 162 | 1.7% |
| 800 | 94 | 1.0% |
| 900 | 72 | 0.7% |
| 1100 | 66 | 0.7% |
| 630 | 63 | 0.6% |
| 830 | 61 | 0.6% |
| 1600 | 60 | 0.6% |
| 730 | 57 | 0.6% |
| 1700 | 55 | 0.6% |
| Other values (1048) | 8862 |
| Value | Count | Frequency (%) |
| 9 | 1 | |
| 14 | 1 | |
| 15 | 2 | |
| 20 | 1 | |
| 30 | 1 | |
| 35 | 1 | |
| 40 | 2 | |
| 44 | 1 | |
| 45 | 2 | |
| 55 | 2 |
| Value | Count | Frequency (%) |
| 2359 | 15 | |
| 2357 | 1 | < 0.1% |
| 2355 | 5 | 0.1% |
| 2354 | 2 | < 0.1% |
| 2353 | 1 | < 0.1% |
| 2350 | 2 | < 0.1% |
| 2349 | 1 | < 0.1% |
| 2348 | 1 | < 0.1% |
| 2346 | 1 | < 0.1% |
| 2345 | 6 | 0.1% |
DEP_TIME
Real number (ℝ)
High correlation
| Distinct | 1184 |
|---|---|
| Distinct (%) | 12.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1339.6814 |
| Minimum | 5 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 602 |
| Q1 | 926 |
| median | 1331 |
| Q3 | 1741 |
| 95-th percentile | 2130.15 |
| Maximum | 2359 |
| Range | 2354 |
| Interquartile range (IQR) | 815 |
Descriptive statistics
| Standard deviation | 498.72675 |
|---|---|
| Coefficient of variation (CV) | 0.37227266 |
| Kurtosis | -0.96495812 |
| Mean | 1339.6814 |
| Median Absolute Deviation (MAD) | 408 |
| Skewness | 0.016165344 |
| Sum | 13072611 |
| Variance | 248728.38 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 555 | 29 | 0.3% |
| 655 | 27 | 0.3% |
| 559 | 27 | 0.3% |
| 558 | 27 | 0.3% |
| 556 | 25 | 0.3% |
| 554 | 25 | 0.3% |
| 656 | 25 | 0.3% |
| 1225 | 23 | 0.2% |
| 1725 | 22 | 0.2% |
| 1054 | 21 | 0.2% |
| Other values (1174) | 9507 |
| Value | Count | Frequency (%) |
| 5 | 1 | |
| 6 | 1 | |
| 8 | 1 | |
| 10 | 1 | |
| 12 | 1 | |
| 13 | 1 | |
| 16 | 2 | |
| 17 | 2 | |
| 20 | 1 | |
| 24 | 2 |
| Value | Count | Frequency (%) |
| 2359 | 3 | |
| 2358 | 2 | |
| 2357 | 1 | < 0.1% |
| 2356 | 1 | < 0.1% |
| 2355 | 2 | |
| 2354 | 3 | |
| 2353 | 2 | |
| 2350 | 2 | |
| 2349 | 4 | |
| 2348 | 1 | < 0.1% |
DEP_DELAY
Real number (ℝ)
High correlation Zeros
| Distinct | 285 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.01363 |
| Minimum | -28 |
|---|---|
| Maximum | 1130 |
| Zeros | 463 |
| Zeros (%) | 4.7% |
| Negative | 6015 |
| Negative (%) | 61.6% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | -28 |
|---|---|
| 5-th percentile | -10 |
| Q1 | -6 |
| median | -2 |
| Q3 | 6 |
| 95-th percentile | 71 |
| Maximum | 1130 |
| Range | 1158 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 48.886139 |
|---|---|
| Coefficient of variation (CV) | 4.8819599 |
| Kurtosis | 173.78012 |
| Mean | 10.01363 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 10.508127 |
| Sum | 97713 |
| Variance | 2389.8546 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -5 | 828 | 8.5% |
| -4 | 756 | 7.7% |
| -2 | 663 | 6.8% |
| -3 | 662 | 6.8% |
| -6 | 655 | 6.7% |
| -1 | 571 | 5.9% |
| -7 | 471 | 4.8% |
| 0 | 463 | 4.7% |
| -8 | 402 | 4.1% |
| -9 | 305 | 3.1% |
| Other values (275) | 3982 |
| Value | Count | Frequency (%) |
| -28 | 1 | < 0.1% |
| -26 | 1 | < 0.1% |
| -25 | 4 | < 0.1% |
| -24 | 4 | < 0.1% |
| -23 | 1 | < 0.1% |
| -22 | 1 | < 0.1% |
| -21 | 2 | < 0.1% |
| -20 | 1 | < 0.1% |
| -19 | 4 | < 0.1% |
| -18 | 12 |
| Value | Count | Frequency (%) |
| 1130 | 1 | |
| 1096 | 1 | |
| 1069 | 1 | |
| 1022 | 1 | |
| 951 | 1 | |
| 920 | 1 | |
| 852 | 1 | |
| 825 | 1 | |
| 803 | 1 | |
| 752 | 1 |
TAXI_OUT
Real number (ℝ)
| Distinct | 85 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.541299 |
| Minimum | 2 |
|---|---|
| Maximum | 158 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 11 |
| median | 14 |
| Q3 | 19 |
| 95-th percentile | 33 |
| Maximum | 158 |
| Range | 156 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 9.0154733 |
|---|---|
| Coefficient of variation (CV) | 0.54502812 |
| Kurtosis | 21.423444 |
| Mean | 16.541299 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 3.2458959 |
| Sum | 161410 |
| Variance | 81.278759 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13 | 789 | 8.1% |
| 11 | 784 | 8.0% |
| 12 | 778 | 8.0% |
| 14 | 710 | 7.3% |
| 10 | 698 | 7.2% |
| 15 | 676 | 6.9% |
| 9 | 542 | 5.6% |
| 16 | 532 | 5.5% |
| 17 | 452 | 4.6% |
| 18 | 388 | 4.0% |
| Other values (75) | 3409 |
| Value | Count | Frequency (%) |
| 2 | 1 | < 0.1% |
| 3 | 5 | 0.1% |
| 4 | 8 | 0.1% |
| 5 | 26 | 0.3% |
| 6 | 99 | 1.0% |
| 7 | 215 | 2.2% |
| 8 | 368 | |
| 9 | 542 | |
| 10 | 698 | |
| 11 | 784 |
| Value | Count | Frequency (%) |
| 158 | 1 | |
| 136 | 1 | |
| 106 | 1 | |
| 105 | 2 | |
| 92 | 1 | |
| 90 | 1 | |
| 89 | 2 | |
| 85 | 2 | |
| 83 | 1 | |
| 82 | 1 |
WHEELS_OFF
Real number (ℝ)
High correlation
| Distinct | 1190 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1362.7527 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 617 |
| Q1 | 941 |
| median | 1344 |
| Q3 | 1756 |
| 95-th percentile | 2143.15 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 815 |
Descriptive statistics
| Standard deviation | 500.66993 |
|---|---|
| Coefficient of variation (CV) | 0.36739602 |
| Kurtosis | -0.90052907 |
| Mean | 1362.7527 |
| Median Absolute Deviation (MAD) | 407 |
| Skewness | -0.016190699 |
| Sum | 13297741 |
| Variance | 250670.38 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1022 | 24 | 0.2% |
| 610 | 23 | 0.2% |
| 1621 | 21 | 0.2% |
| 740 | 20 | 0.2% |
| 913 | 19 | 0.2% |
| 1201 | 19 | 0.2% |
| 617 | 19 | 0.2% |
| 707 | 18 | 0.2% |
| 717 | 18 | 0.2% |
| 1029 | 18 | 0.2% |
| Other values (1180) | 9559 |
| Value | Count | Frequency (%) |
| 1 | 2 | |
| 2 | 2 | |
| 4 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 2 | |
| 10 | 3 | |
| 11 | 1 | < 0.1% |
| 12 | 2 | |
| 13 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2400 | 2 | < 0.1% |
| 2359 | 2 | < 0.1% |
| 2358 | 5 | |
| 2357 | 1 | < 0.1% |
| 2356 | 3 | |
| 2354 | 4 | |
| 2353 | 1 | < 0.1% |
| 2351 | 1 | < 0.1% |
| 2350 | 2 | < 0.1% |
| 2348 | 6 |
WHEELS_ON
Real number (ℝ)
High correlation
| Distinct | 1248 |
|---|---|
| Distinct (%) | 12.8% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1476.5719 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 685.65 |
| Q1 | 1100 |
| median | 1513 |
| Q3 | 1914 |
| 95-th percentile | 2251 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 814 |
Descriptive statistics
| Standard deviation | 524.65085 |
|---|---|
| Coefficient of variation (CV) | 0.35531684 |
| Kurtosis | -0.44881106 |
| Mean | 1476.5719 |
| Median Absolute Deviation (MAD) | 407 |
| Skewness | -0.3229741 |
| Sum | 14402482 |
| Variance | 275258.51 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1317 | 22 | 0.2% |
| 1451 | 19 | 0.2% |
| 2215 | 19 | 0.2% |
| 1241 | 18 | 0.2% |
| 1843 | 18 | 0.2% |
| 1337 | 18 | 0.2% |
| 1203 | 18 | 0.2% |
| 1516 | 18 | 0.2% |
| 1903 | 18 | 0.2% |
| 1832 | 18 | 0.2% |
| Other values (1238) | 9568 |
| Value | Count | Frequency (%) |
| 1 | 6 | |
| 2 | 4 | |
| 3 | 3 | |
| 4 | 5 | |
| 6 | 4 | |
| 8 | 2 | < 0.1% |
| 9 | 4 | |
| 10 | 3 | |
| 11 | 1 | < 0.1% |
| 12 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 2400 | 7 | |
| 2359 | 5 | |
| 2358 | 1 | < 0.1% |
| 2357 | 5 | |
| 2356 | 4 | |
| 2355 | 6 | |
| 2354 | 6 | |
| 2353 | 8 | |
| 2352 | 4 | |
| 2351 | 6 |
TAXI_IN
Real number (ℝ)
| Distinct | 64 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.5596678 |
| Minimum | 1 |
|---|---|
| Maximum | 84 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 17 |
| Maximum | 84 |
| Range | 83 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 6.0813867 |
|---|---|
| Coefficient of variation (CV) | 0.80445157 |
| Kurtosis | 28.885577 |
| Mean | 7.5596678 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 4.1784862 |
| Sum | 73737 |
| Variance | 36.983264 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4 | 1551 | |
| 5 | 1351 | |
| 6 | 1189 | |
| 3 | 1076 | |
| 7 | 896 | |
| 8 | 693 | |
| 9 | 546 | 5.6% |
| 10 | 422 | 4.3% |
| 2 | 331 | 3.4% |
| 11 | 295 | 3.0% |
| Other values (54) | 1404 |
| Value | Count | Frequency (%) |
| 1 | 16 | 0.2% |
| 2 | 331 | 3.4% |
| 3 | 1076 | |
| 4 | 1551 | |
| 5 | 1351 | |
| 6 | 1189 | |
| 7 | 896 | |
| 8 | 693 | |
| 9 | 546 | 5.6% |
| 10 | 422 | 4.3% |
| Value | Count | Frequency (%) |
| 84 | 1 | < 0.1% |
| 77 | 2 | |
| 76 | 2 | |
| 75 | 1 | < 0.1% |
| 74 | 1 | < 0.1% |
| 72 | 1 | < 0.1% |
| 67 | 2 | |
| 65 | 1 | < 0.1% |
| 64 | 1 | < 0.1% |
| 61 | 3 |
CRS_ARR_TIME
Real number (ℝ)
High correlation
| Distinct | 1171 |
|---|---|
| Distinct (%) | 12.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1502.8471 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 729 |
| Q1 | 1117 |
| median | 1525.5 |
| Q3 | 1923.75 |
| 95-th percentile | 2256 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 806.75 |
Descriptive statistics
| Standard deviation | 507.72583 |
|---|---|
| Coefficient of variation (CV) | 0.33784264 |
| Kurtosis | -0.50218927 |
| Mean | 1502.8471 |
| Median Absolute Deviation (MAD) | 404.5 |
| Skewness | -0.2806888 |
| Sum | 14664782 |
| Variance | 257785.52 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1140 | 33 | 0.3% |
| 1900 | 32 | 0.3% |
| 1825 | 32 | 0.3% |
| 1130 | 32 | 0.3% |
| 2030 | 32 | 0.3% |
| 2005 | 32 | 0.3% |
| 1910 | 31 | 0.3% |
| 1235 | 30 | 0.3% |
| 1440 | 29 | 0.3% |
| 1725 | 29 | 0.3% |
| Other values (1161) | 9446 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 2 | 3 | |
| 3 | 1 | < 0.1% |
| 5 | 4 | |
| 7 | 1 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 3 | |
| 10 | 3 | |
| 11 | 5 | |
| 12 | 3 |
| Value | Count | Frequency (%) |
| 2359 | 25 | |
| 2358 | 10 | 0.1% |
| 2357 | 12 | |
| 2356 | 9 | 0.1% |
| 2355 | 20 | |
| 2354 | 8 | 0.1% |
| 2353 | 6 | 0.1% |
| 2352 | 11 | |
| 2351 | 5 | 0.1% |
| 2350 | 12 |
ARR_TIME
Real number (ℝ)
High correlation
| Distinct | 1237 |
|---|---|
| Distinct (%) | 12.7% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1479.6288 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 659 |
| Q1 | 1102 |
| median | 1517 |
| Q3 | 1918 |
| 95-th percentile | 2253 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 816 |
Descriptive statistics
| Standard deviation | 529.90085 |
|---|---|
| Coefficient of variation (CV) | 0.35813094 |
| Kurtosis | -0.36393678 |
| Mean | 1479.6288 |
| Median Absolute Deviation (MAD) | 408 |
| Skewness | -0.36670321 |
| Sum | 14432299 |
| Variance | 280794.91 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1801 | 22 | 0.2% |
| 1630 | 21 | 0.2% |
| 1845 | 19 | 0.2% |
| 1850 | 19 | 0.2% |
| 1455 | 18 | 0.2% |
| 2120 | 18 | 0.2% |
| 1613 | 18 | 0.2% |
| 1606 | 18 | 0.2% |
| 1936 | 18 | 0.2% |
| 1915 | 17 | 0.2% |
| Other values (1227) | 9566 |
| Value | Count | Frequency (%) |
| 1 | 4 | |
| 2 | 6 | |
| 3 | 3 | |
| 4 | 4 | |
| 5 | 7 | |
| 6 | 2 | < 0.1% |
| 7 | 7 | |
| 8 | 4 | |
| 9 | 5 | |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 2400 | 5 | |
| 2359 | 3 | < 0.1% |
| 2358 | 7 | |
| 2357 | 11 | |
| 2356 | 9 | |
| 2355 | 2 | < 0.1% |
| 2354 | 6 | |
| 2353 | 7 | |
| 2352 | 9 | |
| 2351 | 6 |
ARR_DELAY
Real number (ℝ)
High correlation Zeros
| Distinct | 312 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 19 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9777185 |
| Minimum | -75 |
|---|---|
| Maximum | 1163 |
| Zeros | 173 |
| Zeros (%) | 1.8% |
| Negative | 6357 |
| Negative (%) | 65.1% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | -75 |
|---|---|
| 5-th percentile | -28 |
| Q1 | -16 |
| median | -7 |
| Q3 | 6 |
| 95-th percentile | 72 |
| Maximum | 1163 |
| Range | 1238 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 50.820267 |
|---|---|
| Coefficient of variation (CV) | 12.776235 |
| Kurtosis | 152.83043 |
| Mean | 3.9777185 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 9.5272045 |
| Sum | 38739 |
| Variance | 2582.6995 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -10 | 294 | 3.0% |
| -11 | 289 | 3.0% |
| -14 | 287 | 2.9% |
| -9 | 286 | 2.9% |
| -8 | 286 | 2.9% |
| -12 | 273 | 2.8% |
| -13 | 272 | 2.8% |
| -16 | 265 | 2.7% |
| -15 | 264 | 2.7% |
| -17 | 264 | 2.7% |
| Other values (302) | 6959 |
| Value | Count | Frequency (%) |
| -75 | 1 | < 0.1% |
| -63 | 1 | < 0.1% |
| -58 | 1 | < 0.1% |
| -57 | 2 | |
| -56 | 1 | < 0.1% |
| -55 | 1 | < 0.1% |
| -54 | 1 | < 0.1% |
| -53 | 1 | < 0.1% |
| -52 | 2 | |
| -51 | 3 |
| Value | Count | Frequency (%) |
| 1163 | 1 | |
| 1093 | 1 | |
| 1072 | 1 | |
| 1008 | 1 | |
| 944 | 1 | |
| 887 | 1 | |
| 861 | 1 | |
| 808 | 1 | |
| 793 | 1 | |
| 751 | 1 |
CANCELLED
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.8 KiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 9758 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 9758 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 19516 | |
| . | 9758 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 29274 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 19516 | |
| . | 9758 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 29274 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 19516 | |
| . | 9758 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 29274 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 19516 | |
| . | 9758 |
CANCELLATION_CODE
Unsupported
Missing Rejected Unsupported
| Missing | 9758 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 152.5 KiB |
DIVERTED
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.8 KiB |
| 0.0 | |
|---|---|
| 1.0 | 19 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 9739 | |
| 1.0 | 19 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 9739 | |
| 1.0 | 19 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 19497 | |
| . | 9758 | |
| 1 | 19 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 29274 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 19497 | |
| . | 9758 | |
| 1 | 19 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 29274 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 19497 | |
| . | 9758 | |
| 1 | 19 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 29274 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 19497 | |
| . | 9758 | |
| 1 | 19 | 0.1% |
CRS_ELAPSED_TIME
Real number (ℝ)
High correlation
| Distinct | 391 |
|---|---|
| Distinct (%) | 4.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 142.83296 |
| Minimum | 25 |
|---|---|
| Maximum | 680 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 25 |
|---|---|
| 5-th percentile | 63 |
| Q1 | 90 |
| median | 125 |
| Q3 | 174 |
| 95-th percentile | 302.15 |
| Maximum | 680 |
| Range | 655 |
| Interquartile range (IQR) | 84 |
Descriptive statistics
| Standard deviation | 72.696474 |
|---|---|
| Coefficient of variation (CV) | 0.50896148 |
| Kurtosis | 2.6956922 |
| Mean | 142.83296 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 1.4476616 |
| Sum | 1393764 |
| Variance | 5284.7773 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 90 | 201 | 2.1% |
| 85 | 190 | 1.9% |
| 80 | 164 | 1.7% |
| 75 | 149 | 1.5% |
| 70 | 145 | 1.5% |
| 110 | 140 | 1.4% |
| 95 | 138 | 1.4% |
| 100 | 137 | 1.4% |
| 65 | 129 | 1.3% |
| 105 | 121 | 1.2% |
| Other values (381) | 8244 |
| Value | Count | Frequency (%) |
| 25 | 1 | < 0.1% |
| 31 | 1 | < 0.1% |
| 34 | 1 | < 0.1% |
| 35 | 3 | < 0.1% |
| 36 | 6 | 0.1% |
| 37 | 7 | |
| 38 | 3 | < 0.1% |
| 39 | 5 | 0.1% |
| 40 | 16 | |
| 41 | 7 |
| Value | Count | Frequency (%) |
| 680 | 1 | |
| 622 | 1 | |
| 585 | 1 | |
| 580 | 1 | |
| 575 | 2 | |
| 558 | 1 | |
| 548 | 1 | |
| 525 | 1 | |
| 521 | 2 | |
| 484 | 1 |
ELAPSED_TIME
Real number (ℝ)
High correlation
| Distinct | 406 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 19 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 136.85645 |
| Minimum | 26 |
|---|---|
| Maximum | 630 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 26 |
|---|---|
| 5-th percentile | 56 |
| Q1 | 83 |
| median | 119 |
| Q3 | 168 |
| 95-th percentile | 292 |
| Maximum | 630 |
| Range | 604 |
| Interquartile range (IQR) | 85 |
Descriptive statistics
| Standard deviation | 72.731067 |
|---|---|
| Coefficient of variation (CV) | 0.53144054 |
| Kurtosis | 2.6405568 |
| Mean | 136.85645 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 1.4325807 |
| Sum | 1332845 |
| Variance | 5289.8081 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 75 | 96 | 1.0% |
| 76 | 92 | 0.9% |
| 80 | 90 | 0.9% |
| 69 | 88 | 0.9% |
| 105 | 86 | 0.9% |
| 72 | 85 | 0.9% |
| 82 | 85 | 0.9% |
| 77 | 85 | 0.9% |
| 84 | 84 | 0.9% |
| 99 | 83 | 0.9% |
| Other values (396) | 8865 |
| Value | Count | Frequency (%) |
| 26 | 1 | < 0.1% |
| 28 | 1 | < 0.1% |
| 29 | 2 | < 0.1% |
| 31 | 1 | < 0.1% |
| 32 | 7 | |
| 33 | 3 | < 0.1% |
| 34 | 4 | < 0.1% |
| 35 | 5 | |
| 36 | 10 | |
| 37 | 8 |
| Value | Count | Frequency (%) |
| 630 | 1 | |
| 587 | 1 | |
| 585 | 1 | |
| 581 | 1 | |
| 578 | 1 | |
| 574 | 1 | |
| 554 | 1 | |
| 534 | 1 | |
| 527 | 1 | |
| 521 | 1 |
AIR_TIME
Real number (ℝ)
High correlation
| Distinct | 378 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 19 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 112.76301 |
| Minimum | 14 |
|---|---|
| Maximum | 610 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 14 |
|---|---|
| 5-th percentile | 35 |
| Q1 | 61 |
| median | 95 |
| Q3 | 142 |
| 95-th percentile | 268 |
| Maximum | 610 |
| Range | 596 |
| Interquartile range (IQR) | 81 |
Descriptive statistics
| Standard deviation | 70.914231 |
|---|---|
| Coefficient of variation (CV) | 0.62887846 |
| Kurtosis | 2.6874162 |
| Mean | 112.76301 |
| Median Absolute Deviation (MAD) | 39 |
| Skewness | 1.4590352 |
| Sum | 1098199 |
| Variance | 5028.8282 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 57 | 102 | 1.0% |
| 63 | 98 | 1.0% |
| 53 | 94 | 1.0% |
| 61 | 88 | 0.9% |
| 43 | 86 | 0.9% |
| 68 | 86 | 0.9% |
| 59 | 85 | 0.9% |
| 50 | 85 | 0.9% |
| 52 | 85 | 0.9% |
| 85 | 85 | 0.9% |
| Other values (368) | 8845 |
| Value | Count | Frequency (%) |
| 14 | 1 | < 0.1% |
| 15 | 1 | < 0.1% |
| 16 | 1 | < 0.1% |
| 17 | 3 | < 0.1% |
| 18 | 5 | 0.1% |
| 19 | 7 | 0.1% |
| 20 | 12 | |
| 21 | 25 | |
| 22 | 22 | |
| 23 | 18 |
| Value | Count | Frequency (%) |
| 610 | 1 | |
| 564 | 1 | |
| 557 | 1 | |
| 550 | 1 | |
| 544 | 1 | |
| 522 | 1 | |
| 518 | 1 | |
| 502 | 2 | |
| 465 | 1 | |
| 462 | 1 |
DISTANCE
Real number (ℝ)
High correlation
| Distinct | 1306 |
|---|---|
| Distinct (%) | 13.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 815.00676 |
| Minimum | 31 |
|---|---|
| Maximum | 5095 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 31 |
|---|---|
| 5-th percentile | 168.85 |
| Q1 | 371 |
| median | 651 |
| Q3 | 1046 |
| 95-th percentile | 2153 |
| Maximum | 5095 |
| Range | 5064 |
| Interquartile range (IQR) | 675 |
Descriptive statistics
| Standard deviation | 601.55959 |
|---|---|
| Coefficient of variation (CV) | 0.7381038 |
| Kurtosis | 3.2607053 |
| Mean | 815.00676 |
| Median Absolute Deviation (MAD) | 321 |
| Skewness | 1.5551843 |
| Sum | 7952836 |
| Variance | 361873.94 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 337 | 59 | 0.6% |
| 296 | 54 | 0.6% |
| 214 | 45 | 0.5% |
| 224 | 45 | 0.5% |
| 862 | 43 | 0.4% |
| 733 | 42 | 0.4% |
| 399 | 41 | 0.4% |
| 391 | 41 | 0.4% |
| 588 | 36 | 0.4% |
| 957 | 36 | 0.4% |
| Other values (1296) | 9316 |
| Value | Count | Frequency (%) |
| 31 | 1 | < 0.1% |
| 67 | 1 | < 0.1% |
| 68 | 4 | < 0.1% |
| 73 | 9 | |
| 74 | 3 | < 0.1% |
| 75 | 12 | |
| 76 | 3 | < 0.1% |
| 77 | 3 | < 0.1% |
| 82 | 3 | < 0.1% |
| 83 | 8 |
| Value | Count | Frequency (%) |
| 5095 | 2 | |
| 4983 | 2 | |
| 4962 | 1 | < 0.1% |
| 4502 | 1 | < 0.1% |
| 4243 | 3 | |
| 3972 | 1 | < 0.1% |
| 3904 | 3 | |
| 3801 | 2 | |
| 3784 | 3 | |
| 3711 | 1 | < 0.1% |
DELAY_DUE_CARRIER
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 161 |
|---|---|
| Distinct (%) | 9.3% |
| Missing | 8021 |
| Missing (%) | 82.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.559585 |
| Minimum | 0 |
|---|---|
| Maximum | 1130 |
| Zeros | 762 |
| Zeros (%) | 7.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 4 |
| Q3 | 22 |
| 95-th percentile | 97.4 |
| Maximum | 1130 |
| Range | 1130 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 69.132695 |
|---|---|
| Coefficient of variation (CV) | 2.9343765 |
| Kurtosis | 126.99592 |
| Mean | 23.559585 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 9.8124804 |
| Sum | 40923 |
| Variance | 4779.3295 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 762 | 7.8% |
| 1 | 40 | 0.4% |
| 6 | 34 | 0.3% |
| 8 | 32 | 0.3% |
| 3 | 31 | 0.3% |
| 5 | 29 | 0.3% |
| 2 | 29 | 0.3% |
| 4 | 29 | 0.3% |
| 17 | 28 | 0.3% |
| 13 | 27 | 0.3% |
| Other values (151) | 696 | 7.1% |
| (Missing) | 8021 |
| Value | Count | Frequency (%) |
| 0 | 762 | |
| 1 | 40 | 0.4% |
| 2 | 29 | 0.3% |
| 3 | 31 | 0.3% |
| 4 | 29 | 0.3% |
| 5 | 29 | 0.3% |
| 6 | 34 | 0.3% |
| 7 | 25 | 0.3% |
| 8 | 32 | 0.3% |
| 9 | 22 | 0.2% |
| Value | Count | Frequency (%) |
| 1130 | 1 | |
| 1093 | 1 | |
| 998 | 1 | |
| 887 | 1 | |
| 793 | 1 | |
| 706 | 1 | |
| 683 | 1 | |
| 469 | 1 | |
| 445 | 1 | |
| 289 | 1 |
DELAY_DUE_WEATHER
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 60 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 8021 |
| Missing (%) | 82.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.7063903 |
| Minimum | 0 |
|---|---|
| Maximum | 751 |
| Zeros | 1640 |
| Zeros (%) | 16.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 6 |
| Maximum | 751 |
| Range | 751 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 33.492453 |
|---|---|
| Coefficient of variation (CV) | 9.0364073 |
| Kurtosis | 328.52095 |
| Mean | 3.7063903 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.810881 |
| Sum | 6438 |
| Variance | 1121.7444 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1640 | 16.8% |
| 6 | 5 | 0.1% |
| 10 | 5 | 0.1% |
| 24 | 4 | < 0.1% |
| 39 | 4 | < 0.1% |
| 15 | 3 | < 0.1% |
| 26 | 3 | < 0.1% |
| 2 | 3 | < 0.1% |
| 44 | 2 | < 0.1% |
| 76 | 2 | < 0.1% |
| Other values (50) | 66 | 0.7% |
| (Missing) | 8021 |
| Value | Count | Frequency (%) |
| 0 | 1640 | |
| 2 | 3 | < 0.1% |
| 3 | 2 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 2 | < 0.1% |
| 6 | 5 | 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 2 | < 0.1% |
| 10 | 5 | 0.1% |
| 11 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 751 | 1 | |
| 668 | 1 | |
| 667 | 1 | |
| 312 | 1 | |
| 256 | 1 | |
| 235 | 1 | |
| 227 | 1 | |
| 176 | 1 | |
| 155 | 1 | |
| 153 | 1 |
DELAY_DUE_NAS
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 111 |
|---|---|
| Distinct (%) | 6.4% |
| Missing | 8021 |
| Missing (%) | 82.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.095567 |
| Minimum | 0 |
|---|---|
| Maximum | 944 |
| Zeros | 894 |
| Zeros (%) | 9.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 17 |
| 95-th percentile | 52 |
| Maximum | 944 |
| Range | 944 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 35.043309 |
|---|---|
| Coefficient of variation (CV) | 2.6759673 |
| Kurtosis | 298.59972 |
| Mean | 13.095567 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 13.092185 |
| Sum | 22747 |
| Variance | 1228.0335 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 894 | 9.2% |
| 1 | 41 | 0.4% |
| 2 | 38 | 0.4% |
| 15 | 34 | 0.3% |
| 3 | 34 | 0.3% |
| 5 | 34 | 0.3% |
| 17 | 32 | 0.3% |
| 7 | 30 | 0.3% |
| 4 | 29 | 0.3% |
| 6 | 26 | 0.3% |
| Other values (101) | 545 | 5.6% |
| (Missing) | 8021 |
| Value | Count | Frequency (%) |
| 0 | 894 | |
| 1 | 41 | 0.4% |
| 2 | 38 | 0.4% |
| 3 | 34 | 0.3% |
| 4 | 29 | 0.3% |
| 5 | 34 | 0.3% |
| 6 | 26 | 0.3% |
| 7 | 30 | 0.3% |
| 8 | 23 | 0.2% |
| 9 | 25 | 0.3% |
| Value | Count | Frequency (%) |
| 944 | 1 | |
| 318 | 1 | |
| 287 | 1 | |
| 253 | 1 | |
| 242 | 1 | |
| 235 | 1 | |
| 230 | 1 | |
| 221 | 1 | |
| 210 | 1 | |
| 196 | 1 |
DELAY_DUE_SECURITY
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 8021 |
| Missing (%) | 82.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.19976972 |
| Minimum | 0 |
|---|---|
| Maximum | 76 |
| Zeros | 1724 |
| Zeros (%) | 17.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 76 |
| Range | 76 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.8569666 |
|---|---|
| Coefficient of variation (CV) | 14.3013 |
| Kurtosis | 422.4753 |
| Mean | 0.19976972 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 19.104438 |
| Sum | 347 |
| Variance | 8.162258 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 0 | 1724 | 17.7% |
| 9 | 2 | < 0.1% |
| 16 | 2 | < 0.1% |
| 76 | 1 | < 0.1% |
| 24 | 1 | < 0.1% |
| 39 | 1 | < 0.1% |
| 30 | 1 | < 0.1% |
| 25 | 1 | < 0.1% |
| 59 | 1 | < 0.1% |
| 19 | 1 | < 0.1% |
| Other values (2) | 2 | < 0.1% |
| (Missing) | 8021 |
| Value | Count | Frequency (%) |
| 0 | 1724 | |
| 9 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
| 15 | 1 | < 0.1% |
| 16 | 2 | < 0.1% |
| 19 | 1 | < 0.1% |
| 24 | 1 | < 0.1% |
| 25 | 1 | < 0.1% |
| 30 | 1 | < 0.1% |
| 39 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 76 | 1 | |
| 59 | 1 | |
| 39 | 1 | |
| 30 | 1 | |
| 25 | 1 | |
| 24 | 1 | |
| 19 | 1 | |
| 16 | 2 | |
| 15 | 1 | |
| 10 | 1 |
DELAY_DUE_LATE_AIRCRAFT
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 184 |
|---|---|
| Distinct (%) | 10.6% |
| Missing | 8021 |
| Missing (%) | 82.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.899252 |
| Minimum | 0 |
|---|---|
| Maximum | 1069 |
| Zeros | 840 |
| Zeros (%) | 8.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 152.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3 |
| Q3 | 34 |
| 95-th percentile | 132 |
| Maximum | 1069 |
| Range | 1069 |
| Interquartile range (IQR) | 34 |
Descriptive statistics
| Standard deviation | 56.366617 |
|---|---|
| Coefficient of variation (CV) | 2.020363 |
| Kurtosis | 84.140137 |
| Mean | 27.899252 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 6.4762384 |
| Sum | 48461 |
| Variance | 3177.1955 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 840 | 8.6% |
| 20 | 23 | 0.2% |
| 15 | 23 | 0.2% |
| 18 | 20 | 0.2% |
| 19 | 20 | 0.2% |
| 16 | 18 | 0.2% |
| 26 | 18 | 0.2% |
| 4 | 18 | 0.2% |
| 14 | 17 | 0.2% |
| 3 | 15 | 0.2% |
| Other values (174) | 725 | 7.4% |
| (Missing) | 8021 |
| Value | Count | Frequency (%) |
| 0 | 840 | |
| 1 | 11 | 0.1% |
| 2 | 14 | 0.1% |
| 3 | 15 | 0.2% |
| 4 | 18 | 0.2% |
| 5 | 10 | 0.1% |
| 6 | 14 | 0.1% |
| 7 | 13 | 0.1% |
| 8 | 15 | 0.2% |
| 9 | 15 | 0.2% |
| Value | Count | Frequency (%) |
| 1069 | 1 | |
| 625 | 1 | |
| 587 | 1 | |
| 485 | 1 | |
| 367 | 1 | |
| 313 | 1 | |
| 290 | 1 | |
| 289 | 1 | |
| 277 | 1 | |
| 262 | 1 |
Interactions
Correlations
| AIRLINE | AIRLINE_CODE | AIRLINE_DOT | AIR_TIME | ARR_DELAY | ARR_TIME | CRS_ARR_TIME | CRS_DEP_TIME | CRS_ELAPSED_TIME | DELAY_DUE_CARRIER | DELAY_DUE_LATE_AIRCRAFT | DELAY_DUE_NAS | DELAY_DUE_SECURITY | DELAY_DUE_WEATHER | DEP_DELAY | DEP_TIME | DISTANCE | DIVERTED | DOT_CODE | ELAPSED_TIME | FL_NUMBER | TAXI_IN | TAXI_OUT | WHEELS_OFF | WHEELS_ON | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AIRLINE | 1.000 | 1.000 | 1.000 | 0.170 | 0.024 | 0.051 | 0.051 | 0.053 | 0.180 | 0.000 | 0.099 | 0.047 | 0.038 | 0.000 | 0.023 | 0.049 | 0.183 | 0.035 | 0.999 | 0.176 | 0.455 | 0.070 | 0.101 | 0.051 | 0.050 |
| AIRLINE_CODE | 1.000 | 1.000 | 1.000 | 0.170 | 0.024 | 0.051 | 0.051 | 0.053 | 0.180 | 0.000 | 0.099 | 0.047 | 0.038 | 0.000 | 0.023 | 0.049 | 0.183 | 0.035 | 0.999 | 0.176 | 0.455 | 0.070 | 0.101 | 0.051 | 0.050 |
| AIRLINE_DOT | 1.000 | 1.000 | 1.000 | 0.170 | 0.024 | 0.051 | 0.051 | 0.053 | 0.180 | 0.000 | 0.099 | 0.047 | 0.038 | 0.000 | 0.023 | 0.049 | 0.183 | 0.035 | 0.999 | 0.176 | 0.455 | 0.070 | 0.101 | 0.051 | 0.050 |
| AIR_TIME | 0.170 | 0.170 | 0.170 | 1.000 | 0.052 | 0.025 | 0.036 | -0.046 | 0.983 | 0.037 | -0.088 | 0.144 | -0.018 | 0.001 | 0.099 | -0.051 | 0.986 | 1.000 | -0.079 | 0.979 | -0.338 | 0.133 | 0.063 | -0.058 | 0.031 |
| ARR_DELAY | 0.024 | 0.024 | 0.024 | 0.052 | 1.000 | 0.110 | 0.107 | 0.125 | -0.011 | 0.171 | 0.405 | 0.050 | -0.021 | 0.101 | 0.650 | 0.163 | 0.023 | 1.000 | -0.053 | 0.117 | -0.045 | 0.115 | 0.267 | 0.170 | 0.117 |
| ARR_TIME | 0.051 | 0.051 | 0.051 | 0.025 | 0.110 | 1.000 | 0.904 | 0.740 | 0.020 | -0.065 | 0.125 | 0.015 | 0.009 | -0.002 | 0.131 | 0.762 | 0.032 | 0.043 | -0.006 | 0.029 | -0.007 | -0.039 | 0.040 | 0.776 | 0.977 |
| CRS_ARR_TIME | 0.051 | 0.051 | 0.051 | 0.036 | 0.107 | 0.904 | 1.000 | 0.802 | 0.033 | -0.060 | 0.185 | -0.013 | -0.006 | 0.035 | 0.137 | 0.799 | 0.046 | 0.000 | -0.002 | 0.037 | -0.021 | -0.038 | 0.030 | 0.810 | 0.911 |
| CRS_DEP_TIME | 0.053 | 0.053 | 0.053 | -0.046 | 0.125 | 0.740 | 0.802 | 1.000 | -0.052 | -0.053 | 0.218 | -0.050 | 0.012 | 0.034 | 0.150 | 0.971 | -0.039 | 0.000 | 0.014 | -0.046 | -0.010 | -0.057 | 0.022 | 0.956 | 0.759 |
| CRS_ELAPSED_TIME | 0.180 | 0.180 | 0.180 | 0.983 | -0.011 | 0.020 | 0.033 | -0.052 | 1.000 | 0.055 | -0.077 | 0.099 | -0.021 | -0.003 | 0.093 | -0.056 | 0.979 | 0.000 | -0.036 | 0.974 | -0.311 | 0.171 | 0.107 | -0.063 | 0.026 |
| DELAY_DUE_CARRIER | 0.000 | 0.000 | 0.000 | 0.037 | 0.171 | -0.065 | -0.060 | -0.053 | 0.055 | 1.000 | -0.281 | -0.330 | -0.065 | -0.233 | 0.272 | -0.035 | 0.066 | 1.000 | -0.099 | -0.008 | 0.007 | -0.122 | -0.093 | -0.048 | -0.072 |
| DELAY_DUE_LATE_AIRCRAFT | 0.099 | 0.099 | 0.099 | -0.088 | 0.405 | 0.125 | 0.185 | 0.218 | -0.077 | -0.281 | 1.000 | -0.250 | -0.036 | -0.025 | 0.488 | 0.262 | -0.068 | 1.000 | -0.042 | -0.147 | 0.023 | -0.102 | -0.150 | 0.241 | 0.129 |
| DELAY_DUE_NAS | 0.047 | 0.047 | 0.047 | 0.144 | 0.050 | 0.015 | -0.013 | -0.050 | 0.099 | -0.330 | -0.250 | 1.000 | -0.045 | -0.006 | -0.325 | -0.071 | 0.082 | 1.000 | 0.181 | 0.301 | -0.056 | 0.310 | 0.447 | -0.041 | 0.017 |
| DELAY_DUE_SECURITY | 0.038 | 0.038 | 0.038 | -0.018 | -0.021 | 0.009 | -0.006 | 0.012 | -0.021 | -0.065 | -0.036 | -0.045 | 1.000 | -0.021 | -0.001 | 0.013 | -0.011 | 1.000 | 0.013 | -0.029 | -0.039 | -0.043 | -0.034 | 0.013 | 0.007 |
| DELAY_DUE_WEATHER | 0.000 | 0.000 | 0.000 | 0.001 | 0.101 | -0.002 | 0.035 | 0.034 | -0.003 | -0.233 | -0.025 | -0.006 | -0.021 | 1.000 | 0.086 | 0.005 | -0.000 | 1.000 | 0.042 | 0.011 | -0.011 | 0.009 | 0.048 | 0.010 | 0.017 |
| DEP_DELAY | 0.023 | 0.023 | 0.023 | 0.099 | 0.650 | 0.131 | 0.137 | 0.150 | 0.093 | 0.272 | 0.488 | -0.325 | -0.001 | 0.086 | 1.000 | 0.195 | 0.109 | 0.101 | -0.190 | 0.098 | -0.083 | -0.059 | 0.027 | 0.193 | 0.139 |
| DEP_TIME | 0.049 | 0.049 | 0.049 | -0.051 | 0.163 | 0.762 | 0.799 | 0.971 | -0.056 | -0.035 | 0.262 | -0.071 | 0.013 | 0.005 | 0.195 | 1.000 | -0.044 | 0.000 | 0.009 | -0.049 | -0.006 | -0.059 | 0.029 | 0.985 | 0.782 |
| DISTANCE | 0.183 | 0.183 | 0.183 | 0.986 | 0.023 | 0.032 | 0.046 | -0.039 | 0.979 | 0.066 | -0.068 | 0.082 | -0.011 | -0.000 | 0.109 | -0.044 | 1.000 | 0.013 | -0.101 | 0.962 | -0.355 | 0.118 | 0.048 | -0.053 | 0.038 |
| DIVERTED | 0.035 | 0.035 | 0.035 | 1.000 | 1.000 | 0.043 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.101 | 0.000 | 0.013 | 1.000 | 0.000 | 1.000 | 0.019 | 0.086 | 0.000 | 0.000 | 0.049 |
| DOT_CODE | 0.999 | 0.999 | 0.999 | -0.079 | -0.053 | -0.006 | -0.002 | 0.014 | -0.036 | -0.099 | -0.042 | 0.181 | 0.013 | 0.042 | -0.190 | 0.009 | -0.101 | 0.000 | 1.000 | -0.020 | 0.319 | 0.213 | 0.278 | 0.013 | -0.006 |
| ELAPSED_TIME | 0.176 | 0.176 | 0.176 | 0.979 | 0.117 | 0.029 | 0.037 | -0.046 | 0.974 | -0.008 | -0.147 | 0.301 | -0.029 | 0.011 | 0.098 | -0.049 | 0.962 | 1.000 | -0.020 | 1.000 | -0.310 | 0.216 | 0.197 | -0.052 | 0.034 |
| FL_NUMBER | 0.455 | 0.455 | 0.455 | -0.338 | -0.045 | -0.007 | -0.021 | -0.010 | -0.311 | 0.007 | 0.023 | -0.056 | -0.039 | -0.011 | -0.083 | -0.006 | -0.355 | 0.019 | 0.319 | -0.310 | 1.000 | -0.044 | 0.090 | 0.002 | -0.015 |
| TAXI_IN | 0.070 | 0.070 | 0.070 | 0.133 | 0.115 | -0.039 | -0.038 | -0.057 | 0.171 | -0.122 | -0.102 | 0.310 | -0.043 | 0.009 | -0.059 | -0.059 | 0.118 | 0.086 | 0.213 | 0.216 | -0.044 | 1.000 | 0.077 | -0.058 | -0.045 |
| TAXI_OUT | 0.101 | 0.101 | 0.101 | 0.063 | 0.267 | 0.040 | 0.030 | 0.022 | 0.107 | -0.093 | -0.150 | 0.447 | -0.034 | 0.048 | 0.027 | 0.029 | 0.048 | 0.000 | 0.278 | 0.197 | 0.090 | 0.077 | 1.000 | 0.048 | 0.044 |
| WHEELS_OFF | 0.051 | 0.051 | 0.051 | -0.058 | 0.170 | 0.776 | 0.810 | 0.956 | -0.063 | -0.048 | 0.241 | -0.041 | 0.013 | 0.010 | 0.193 | 0.985 | -0.053 | 0.000 | 0.013 | -0.052 | 0.002 | -0.058 | 0.048 | 1.000 | 0.796 |
| WHEELS_ON | 0.050 | 0.050 | 0.050 | 0.031 | 0.117 | 0.977 | 0.911 | 0.759 | 0.026 | -0.072 | 0.129 | 0.017 | 0.007 | 0.017 | 0.139 | 0.782 | 0.038 | 0.049 | -0.006 | 0.034 | -0.015 | -0.045 | 0.044 | 0.796 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| FL_DATE | AIRLINE | AIRLINE_DOT | AIRLINE_CODE | DOT_CODE | FL_NUMBER | ORIGIN | ORIGIN_CITY | DEST | DEST_CITY | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | WHEELS_OFF | WHEELS_ON | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | CRS_ELAPSED_TIME | ELAPSED_TIME | AIR_TIME | DISTANCE | DELAY_DUE_CARRIER | DELAY_DUE_WEATHER | DELAY_DUE_NAS | DELAY_DUE_SECURITY | DELAY_DUE_LATE_AIRCRAFT | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2022-07-19 | SkyWest Airlines Inc. | SkyWest Airlines Inc.: OO | OO | 20304 | 3371 | SAN | San Diego, CA | SFO | San Francisco, CA | 1705 | 1700.0 | -5.0 | 13.0 | 1713.0 | 1816.0 | 11.0 | 1834 | 1827.0 | -7.0 | 0.0 | NaN | 0.0 | 89.0 | 87.0 | 63.0 | 447.0 | NaN | NaN | NaN | NaN | NaN |
| 1 | 2022-09-13 | Republic Airline | Republic Airline: YX | YX | 20452 | 3552 | CMH | Columbus, OH | ORD | Chicago, IL | 1119 | 1118.0 | -1.0 | 16.0 | 1134.0 | 1125.0 | 11.0 | 1147 | 1136.0 | -11.0 | 0.0 | NaN | 0.0 | 88.0 | 78.0 | 51.0 | 296.0 | NaN | NaN | NaN | NaN | NaN |
| 2 | 2022-07-09 | SkyWest Airlines Inc. | SkyWest Airlines Inc.: OO | OO | 20304 | 4660 | CVG | Cincinnati, OH | ORD | Chicago, IL | 1118 | 1113.0 | -5.0 | 18.0 | 1131.0 | 1124.0 | 8.0 | 1155 | 1132.0 | -23.0 | 0.0 | NaN | 0.0 | 97.0 | 79.0 | 53.0 | 264.0 | NaN | NaN | NaN | NaN | NaN |
| 3 | 2021-03-19 | United Air Lines Inc. | United Air Lines Inc.: UA | UA | 19977 | 325 | DEN | Denver, CO | MCI | Kansas City, MO | 1815 | 1815.0 | 0.0 | 15.0 | 1830.0 | 2042.0 | 5.0 | 2051 | 2047.0 | -4.0 | 0.0 | NaN | 0.0 | 96.0 | 92.0 | 72.0 | 533.0 | NaN | NaN | NaN | NaN | NaN |
| 4 | 2020-01-03 | United Air Lines Inc. | United Air Lines Inc.: UA | UA | 19977 | 1561 | IAH | Houston, TX | SFO | San Francisco, CA | 1000 | 1001.0 | 1.0 | 21.0 | 1022.0 | 1205.0 | 9.0 | 1227 | 1214.0 | -13.0 | 0.0 | NaN | 0.0 | 267.0 | 253.0 | 223.0 | 1635.0 | NaN | NaN | NaN | NaN | NaN |
| 5 | 2023-06-18 | SkyWest Airlines Inc. | SkyWest Airlines Inc.: OO | OO | 20304 | 3703 | ATW | Appleton, WI | DTW | Detroit, MI | 1659 | 1650.0 | -9.0 | 19.0 | 1709.0 | 1856.0 | 14.0 | 1926 | 1910.0 | -16.0 | 0.0 | NaN | 0.0 | 87.0 | 80.0 | 47.0 | 296.0 | NaN | NaN | NaN | NaN | NaN |
| 6 | 2023-05-20 | SkyWest Airlines Inc. | SkyWest Airlines Inc.: OO | OO | 20304 | 4874 | ABQ | Albuquerque, NM | LAX | Los Angeles, CA | 1334 | 1330.0 | -4.0 | 12.0 | 1342.0 | 1429.0 | 5.0 | 1445 | 1434.0 | -11.0 | 0.0 | NaN | 0.0 | 131.0 | 124.0 | 107.0 | 677.0 | NaN | NaN | NaN | NaN | NaN |
| 7 | 2019-09-23 | PSA Airlines Inc. | PSA Airlines Inc.: OH | OH | 20397 | 5644 | CRW | Charleston/Dunbar, WV | CLT | Charlotte, NC | 902 | 858.0 | -4.0 | 22.0 | 920.0 | 1002.0 | 16.0 | 1030 | 1018.0 | -12.0 | 0.0 | NaN | 0.0 | 88.0 | 80.0 | 42.0 | 221.0 | NaN | NaN | NaN | NaN | NaN |
| 8 | 2022-04-23 | Endeavor Air Inc. | Endeavor Air Inc.: 9E | 9E | 20363 | 4809 | TRI | Bristol/Johnson City/Kingsport, TN | ATL | Atlanta, GA | 600 | 558.0 | -2.0 | 16.0 | 614.0 | 654.0 | 4.0 | 705 | 658.0 | -7.0 | 0.0 | NaN | 0.0 | 65.0 | 60.0 | 40.0 | 227.0 | NaN | NaN | NaN | NaN | NaN |
| 9 | 2019-11-22 | Spirit Air Lines | Spirit Air Lines: NK | NK | 20416 | 612 | LAS | Las Vegas, NV | MSP | Minneapolis, MN | 126 | 122.0 | -4.0 | 10.0 | 132.0 | 620.0 | 4.0 | 625 | 624.0 | -1.0 | 0.0 | NaN | 0.0 | 179.0 | 182.0 | 168.0 | 1299.0 | NaN | NaN | NaN | NaN | NaN |
| FL_DATE | AIRLINE | AIRLINE_DOT | AIRLINE_CODE | DOT_CODE | FL_NUMBER | ORIGIN | ORIGIN_CITY | DEST | DEST_CITY | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | WHEELS_OFF | WHEELS_ON | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | CRS_ELAPSED_TIME | ELAPSED_TIME | AIR_TIME | DISTANCE | DELAY_DUE_CARRIER | DELAY_DUE_WEATHER | DELAY_DUE_NAS | DELAY_DUE_SECURITY | DELAY_DUE_LATE_AIRCRAFT | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9990 | 2023-02-23 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 2437 | ONT | Ontario, CA | OAK | Oakland, CA | 810 | 810.0 | 0.0 | 6.0 | 816.0 | 920.0 | 3.0 | 930 | 923.0 | -7.0 | 0.0 | NaN | 0.0 | 80.0 | 73.0 | 64.0 | 362.0 | NaN | NaN | NaN | NaN | NaN |
| 9991 | 2021-09-22 | United Air Lines Inc. | United Air Lines Inc.: UA | UA | 19977 | 252 | HNL | Honolulu, HI | IAH | Houston, TX | 1945 | 1937.0 | -8.0 | 22.0 | 1959.0 | 808.0 | 3.0 | 814 | 811.0 | -3.0 | 0.0 | NaN | 0.0 | 449.0 | 454.0 | 429.0 | 3904.0 | NaN | NaN | NaN | NaN | NaN |
| 9992 | 2023-04-10 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 1580 | RIC | Richmond, VA | ATL | Atlanta, GA | 1720 | 1716.0 | -4.0 | 14.0 | 1730.0 | 1842.0 | 6.0 | 1905 | 1848.0 | -17.0 | 0.0 | NaN | 0.0 | 105.0 | 92.0 | 72.0 | 481.0 | NaN | NaN | NaN | NaN | NaN |
| 9993 | 2019-07-20 | Alaska Airlines Inc. | Alaska Airlines Inc.: AS | AS | 19930 | 708 | SFO | San Francisco, CA | RDU | Raleigh/Durham, NC | 2120 | 2119.0 | -1.0 | 15.0 | 2134.0 | 534.0 | 5.0 | 535 | 539.0 | 4.0 | 0.0 | NaN | 0.0 | 315.0 | 320.0 | 300.0 | 2400.0 | NaN | NaN | NaN | NaN | NaN |
| 9994 | 2022-04-12 | Republic Airline | Republic Airline: YX | YX | 20452 | 5700 | BOS | Boston, MA | CHS | Charleston, SC | 1210 | 1228.0 | 18.0 | 16.0 | 1244.0 | 1447.0 | 10.0 | 1449 | 1457.0 | 8.0 | 0.0 | NaN | 0.0 | 159.0 | 149.0 | 123.0 | 818.0 | NaN | NaN | NaN | NaN | NaN |
| 9995 | 2022-06-21 | Envoy Air | Envoy Air: MQ | MQ | 20398 | 3738 | DSM | Des Moines, IA | DFW | Dallas/Fort Worth, TX | 1121 | 1110.0 | -11.0 | 10.0 | 1120.0 | 1247.0 | 8.0 | 1322 | 1255.0 | -27.0 | 0.0 | NaN | 0.0 | 121.0 | 105.0 | 87.0 | 624.0 | NaN | NaN | NaN | NaN | NaN |
| 9996 | 2023-06-23 | United Air Lines Inc. | United Air Lines Inc.: UA | UA | 19977 | 2676 | ORD | Chicago, IL | PDX | Portland, OR | 2003 | 2131.0 | 88.0 | 30.0 | 2201.0 | 2358.0 | 4.0 | 2226 | 2.0 | 96.0 | 0.0 | NaN | 0.0 | 263.0 | 271.0 | 237.0 | 1739.0 | 26.0 | 0.0 | 8.0 | 0.0 | 62.0 |
| 9997 | 2022-02-07 | PSA Airlines Inc. | PSA Airlines Inc.: OH | OH | 20397 | 5058 | PHL | Philadelphia, PA | GSP | Greer, SC | 1816 | 2047.0 | 151.0 | 17.0 | 2104.0 | 2231.0 | 3.0 | 2009 | 2234.0 | 145.0 | 0.0 | NaN | 0.0 | 113.0 | 107.0 | 87.0 | 515.0 | 0.0 | 0.0 | 0.0 | 0.0 | 145.0 |
| 9998 | 2020-03-12 | JetBlue Airways | JetBlue Airways: B6 | B6 | 20409 | 1286 | PIT | Pittsburgh, PA | BOS | Boston, MA | 838 | 826.0 | -12.0 | 10.0 | 836.0 | 947.0 | 5.0 | 1012 | 952.0 | -20.0 | 0.0 | NaN | 0.0 | 94.0 | 86.0 | 71.0 | 496.0 | NaN | NaN | NaN | NaN | NaN |
| 9999 | 2021-03-14 | Endeavor Air Inc. | Endeavor Air Inc.: 9E | 9E | 20363 | 5111 | ABE | Allentown/Bethlehem/Easton, PA | ATL | Atlanta, GA | 640 | 705.0 | 25.0 | 12.0 | 717.0 | 902.0 | 5.0 | 903 | 907.0 | 4.0 | 0.0 | NaN | 0.0 | 143.0 | 122.0 | 105.0 | 692.0 | NaN | NaN | NaN | NaN | NaN |